Reviews data profiling

Dataset statistics

Number of variables	15
Number of observations	30000
Missing cells	74980
Missing cells (%)	16.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	37.5 MiB
Average record size in memory	1.3 KiB

Variable types

Text	10
Boolean	2
Categorical	3

Alerts

`reviews_doRecommend` is highly overall correlated with `reviews_rating` and 1 other fields	High correlation
`reviews_rating` is highly overall correlated with `reviews_doRecommend`	High correlation
`reviews_userProvince` is highly overall correlated with `reviews_doRecommend`	High correlation
`reviews_didPurchase` is highly imbalanced (56.4%)	Imbalance
`reviews_doRecommend` is highly imbalanced (68.7%)	Imbalance
`reviews_didPurchase` has 14068 (46.9%) missing values	Missing
`reviews_doRecommend` has 2570 (8.6%) missing values	Missing
`reviews_userCity` has 28071 (93.6%) missing values	Missing
`reviews_userProvince` has 29830 (99.4%) missing values	Missing

Reproduction

Analysis started	2024-06-23 10:21:44.642440
Analysis finished	2024-06-23 10:21:46.382621
Duration	1.74 second
Software version	ydata-profiling v4.8.3
Download configuration	config.json

id
Text

Distinct	271
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	2.2 MiB

Length

Max length	20
Median length	20
Mean length	20
Min length	20

Characters and Unicode

Total characters	600000
Distinct characters	64
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	49 ?
Unique (%)	0.2%

Sample

1st row	AV13O1A8GV-KLJ3akUyj
2nd row	AV14LG0R-jtxr-f38QfS
3rd row	AV14LG0R-jtxr-f38QfS
4th row	AV16khLE-jtxr-f38VFn
5th row	AV16khLE-jtxr-f38VFn

Value	Count	Frequency (%)
avpf3vofilapnd_xjpun	8545	28.5%
avpfpaoqljejml435xk9	3325	11.1%
avpfjp1c1cnluz0-e3xy	2039	6.8%
avpfw8y_ljejml437ysw	1186	4.0%
avpfrth1ilapnd_xyic2	1143	3.8%
avpf63ajljejml43f__q	873	2.9%
avpf0eb2ljejml43evst	845	2.8%
avpe41tqilapnd_xqh3d	757	2.5%
avpfm8yiljejml43ayyu	693	2.3%
avpf2tw1ilapnd_xjflc	672	2.2%
Other values (261)	9922	33.1%

Most occurring characters

Value	Count	Frequency (%)
A	45592	7.6%
V	41098	6.8%
p	38641	6.4%
f	35966	6.0%
n	29274	4.9%
3	24175	4.0%
J	23350	3.9%
l	21320	3.6%
L	20965	3.5%
P	20151	3.4%
Other values (54)	299468	49.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	600000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	45592	7.6%
V	41098	6.8%
p	38641	6.4%
f	35966	6.0%
n	29274	4.9%
3	24175	4.0%
J	23350	3.9%
l	21320	3.6%
L	20965	3.5%
P	20151	3.4%
Other values (54)	299468	49.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	600000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	45592	7.6%
V	41098	6.8%
p	38641	6.4%
f	35966	6.0%
n	29274	4.9%
3	24175	4.0%
J	23350	3.9%
l	21320	3.6%
L	20965	3.5%
P	20151	3.4%
Other values (54)	299468	49.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	600000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	45592	7.6%
V	41098	6.8%
p	38641	6.4%
f	35966	6.0%
n	29274	4.9%
3	24175	4.0%
J	23350	3.9%
l	21320	3.6%
L	20965	3.5%
P	20151	3.4%
Other values (54)	299468	49.9%

brand
Text

Distinct	214
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	1.9 MiB

Length

Max length	30
Median length	28
Mean length	9.3696667
Min length	3

Characters and Unicode

Total characters	281090
Distinct characters	58
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	34 ?
Unique (%)	0.1%

Sample

1st row	Universal Music
2nd row	Lundberg
3rd row	Lundberg
4th row	K-Y
5th row	K-Y

Value	Count	Frequency (%)
clorox	10585	22.9%
home	4058	8.8%
warner	3994	8.6%
video	3993	8.6%
l'oreal	1310	2.8%
paris	1310	2.8%
disney	1200	2.6%
sony	891	1.9%
fox	887	1.9%
burt's	881	1.9%
Other values (293)	17185	37.1%

Most occurring characters

Value	Count	Frequency (%)
o	36010	12.8%
r	30031	10.7%
e	27968	9.9%
	16294	5.8%
l	15720	5.6%
a	13850	4.9%
i	12814	4.6%
n	12812	4.6%
x	12777	4.5%
C	12024	4.3%
Other values (48)	90790	32.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	281090	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	36010	12.8%
r	30031	10.7%
e	27968	9.9%
	16294	5.8%
l	15720	5.6%
a	13850	4.9%
i	12814	4.6%
n	12812	4.6%
x	12777	4.5%
C	12024	4.3%
Other values (48)	90790	32.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	281090	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	36010	12.8%
r	30031	10.7%
e	27968	9.9%
	16294	5.8%
l	15720	5.6%
a	13850	4.9%
i	12814	4.6%
n	12812	4.6%
x	12777	4.5%
C	12024	4.3%
Other values (48)	90790	32.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	281090	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	36010	12.8%
r	30031	10.7%
e	27968	9.9%
	16294	5.8%
l	15720	5.6%
a	13850	4.9%
i	12814	4.6%
n	12812	4.6%
x	12777	4.5%
C	12024	4.3%
Other values (48)	90790	32.3%

categories
Text

Distinct	270
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	9.1 MiB

Length

Max length	518
Median length	374
Mean length	262.18357
Min length	42

Characters and Unicode

Total characters	7865507
Distinct characters	71
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	48 ?
Unique (%)	0.2%

Sample

1st row	Movies, Music & Books,Music,R&b,Movies & TV,Movie Bundles & Collections,CDs & Vinyl,Rap & Hip-Hop,Bass,Music on CD or Vinyl,Rap,Hip-Hop,Mainstream Rap,Pop Rap
2nd row	Food,Packaged Foods,Snacks,Crackers,Snacks, Cookies & Chips,Rice Cakes,Cakes
3rd row	Food,Packaged Foods,Snacks,Crackers,Snacks, Cookies & Chips,Rice Cakes,Cakes
4th row	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants
5th row	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants

Value	Count	Frequency (%)
	153588	21.5%
to	14333	2.0%
and	13005	1.8%
movies	12608	1.8%
tv	12200	1.7%
household	11321	1.6%
household,household	11218	1.6%
supplies,household	11107	1.6%
storage	11077	1.6%
brands,home	11065	1.5%
Other values (1885)	452408	63.4%

Most occurring characters

Value	Count	Frequency (%)
e	721512	9.2%
	689330	8.8%
s	606910	7.7%
o	539027	6.9%
a	470043	6.0%
,	464769	5.9%
i	410763	5.2%
n	410185	5.2%
l	397456	5.1%
r	380680	4.8%
Other values (61)	2774832	35.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7865507	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	721512	9.2%
	689330	8.8%
s	606910	7.7%
o	539027	6.9%
a	470043	6.0%
,	464769	5.9%
i	410763	5.2%
n	410185	5.2%
l	397456	5.1%
r	380680	4.8%
Other values (61)	2774832	35.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7865507	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	721512	9.2%
	689330	8.8%
s	606910	7.7%
o	539027	6.9%
a	470043	6.0%
,	464769	5.9%
i	410763	5.2%
n	410185	5.2%
l	397456	5.1%
r	380680	4.8%
Other values (61)	2774832	35.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7865507	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	721512	9.2%
	689330	8.8%
s	606910	7.7%
o	539027	6.9%
a	470043	6.0%
,	464769	5.9%
i	410763	5.2%
n	410185	5.2%
l	397456	5.1%
r	380680	4.8%
Other values (61)	2774832	35.3%

manufacturer
Text

Distinct	227
Distinct (%)	0.8%
Missing	141
Missing (%)	0.5%
Memory size	1.9 MiB

Length

Max length	36
Median length	31
Mean length	9.8143608
Min length	3

Characters and Unicode

Total characters	293047
Distinct characters	65
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	40 ?
Unique (%)	0.1%

Sample

1st row	Universal Music Group / Cash Money
2nd row	Lundberg
3rd row	Lundberg
4th row	K-Y
5th row	K-Y

Value	Count	Frequency (%)
clorox	8546	19.0%
test	3325	7.4%
amazonus/cloo7	2039	4.5%
l'oreal	1254	2.8%
paris	1232	2.7%
disney	1173	2.6%
walt	1172	2.6%
fox	887	2.0%
century	887	2.0%
bees	881	2.0%
Other values (343)	23491	52.3%

Most occurring characters

Value	Count	Frequency (%)
o	29131	9.9%
e	22638	7.7%
r	21623	7.4%
s	15641	5.3%
t	15583	5.3%
	15028	5.1%
C	14522	5.0%
l	13884	4.7%
n	13500	4.6%
a	13148	4.5%
Other values (55)	118349	40.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	293047	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	29131	9.9%
e	22638	7.7%
r	21623	7.4%
s	15641	5.3%
t	15583	5.3%
	15028	5.1%
C	14522	5.0%
l	13884	4.7%
n	13500	4.6%
a	13148	4.5%
Other values (55)	118349	40.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	293047	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	29131	9.9%
e	22638	7.7%
r	21623	7.4%
s	15641	5.3%
t	15583	5.3%
	15028	5.1%
C	14522	5.0%
l	13884	4.7%
n	13500	4.6%
a	13148	4.5%
Other values (55)	118349	40.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	293047	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	29131	9.9%
e	22638	7.7%
r	21623	7.4%
s	15641	5.3%
t	15583	5.3%
	15028	5.1%
C	14522	5.0%
l	13884	4.7%
n	13500	4.6%
a	13148	4.5%
Other values (55)	118349	40.4%

name
Text

Distinct	271
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Length

Max length	103
Median length	93
Mean length	53.391367
Min length	13

Characters and Unicode

Total characters	1601741
Distinct characters	76
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	49 ?
Unique (%)	0.2%

Sample

1st row	Pink Friday: Roman Reloaded Re-Up (w/dvd)
2nd row	Lundberg Organic Cinnamon Toast Rice Cakes
3rd row	Lundberg Organic Cinnamon Toast Rice Cakes
4th row	K-Y Love Sensuality Pleasure Gel
5th row	K-Y Love Sensuality Pleasure Gel

Value	Count	Frequency (%)
clorox	10585	4.5%
disinfecting	10584	4.5%
total	8917	3.8%
pack	8567	3.7%
wipes	8561	3.7%
ct	8546	3.7%
value	8545	3.6%
scented	8545	3.6%
150	8545	3.6%
digital	6140	2.6%
Other values (1238)	146589	62.6%

Most occurring characters

Value	Count	Frequency (%)
	204124	12.7%
e	125397	7.8%
i	110828	6.9%
a	90397	5.6%
l	88982	5.6%
t	86526	5.4%
o	79931	5.0%
n	73270	4.6%
d	59106	3.7%
r	57085	3.6%
Other values (66)	626095	39.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1601741	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	204124	12.7%
e	125397	7.8%
i	110828	6.9%
a	90397	5.6%
l	88982	5.6%
t	86526	5.4%
o	79931	5.0%
n	73270	4.6%
d	59106	3.7%
r	57085	3.6%
Other values (66)	626095	39.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1601741	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	204124	12.7%
e	125397	7.8%
i	110828	6.9%
a	90397	5.6%
l	88982	5.6%
t	86526	5.4%
o	79931	5.0%
n	73270	4.6%
d	59106	3.7%
r	57085	3.6%
Other values (66)	626095	39.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1601741	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	204124	12.7%
e	125397	7.8%
i	110828	6.9%
a	90397	5.6%
l	88982	5.6%
t	86526	5.4%
o	79931	5.0%
n	73270	4.6%
d	59106	3.7%
r	57085	3.6%
Other values (66)	626095	39.1%

reviews_date
Text

Distinct	6857
Distinct (%)	22.9%
Missing	46
Missing (%)	0.2%
Memory size	2.3 MiB

Length

Max length	50
Median length	24
Mean length	23.914669
Min length	20

Characters and Unicode

Total characters	716340
Distinct characters	33
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4798 ?
Unique (%)	16.0%

Sample

1st row	2012-11-30T06:21:45.000Z
2nd row	2017-07-09T00:00:00.000Z
3rd row	2017-07-09T00:00:00.000Z
4th row	2016-01-06T00:00:00.000Z
5th row	2016-12-21T00:00:00.000Z

Value	Count	Frequency (%)
2012-01-26t00:00:00.000z	1041	3.5%
2014-12-03t00:00:00.000z	524	1.7%
2014-09-19t00:00:00.000z	406	1.4%
2014-12-05t00:00:00.000z	345	1.1%
2014-12-04t00:00:00.000z	301	1.0%
2012-01-27t00:00:00.000z	300	1.0%
2014-11-07t00:00:00.000z	289	1.0%
2012-01-28t00:00:00.000z	278	0.9%
2014-12-27t00:00:00.000z	232	0.8%
2014-12-06t00:00:00.000z	208	0.7%
Other values (6854)	26086	86.9%

Most occurring characters

Value	Count	Frequency (%)
0	313683	43.8%
1	64334	9.0%
-	59892	8.4%
:	59892	8.4%
2	59753	8.3%
T	29946	4.2%
Z	29946	4.2%
.	29263	4.1%
4	14752	2.1%
5	12918	1.8%
Other values (23)	41961	5.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	716340	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	313683	43.8%
1	64334	9.0%
-	59892	8.4%
:	59892	8.4%
2	59753	8.3%
T	29946	4.2%
Z	29946	4.2%
.	29263	4.1%
4	14752	2.1%
5	12918	1.8%
Other values (23)	41961	5.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	716340	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	313683	43.8%
1	64334	9.0%
-	59892	8.4%
:	59892	8.4%
2	59753	8.3%
T	29946	4.2%
Z	29946	4.2%
.	29263	4.1%
4	14752	2.1%
5	12918	1.8%
Other values (23)	41961	5.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	716340	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	313683	43.8%
1	64334	9.0%
-	59892	8.4%
:	59892	8.4%
2	59753	8.3%
T	29946	4.2%
Z	29946	4.2%
.	29263	4.1%
4	14752	2.1%
5	12918	1.8%
Other values (23)	41961	5.9%

reviews_didPurchase
Boolean

IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	14068
Missing (%)	46.9%
Memory size	999.9 KiB

False	14498
True	1434
(Missing)	14068

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	14498	48.3%
True	1434	4.8%
(Missing)	14068	46.9%

reviews_doRecommend
Boolean

HIGH CORRELATION IMBALANCE MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	2570
Missing (%)	8.6%
Memory size	1.0 MiB

True	25880
False	1550
(Missing)	2570

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	25880	86.3%
False	1550	5.2%
(Missing)	2570	8.6%

reviews_rating
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

5	20831
4	6020
1	1384
3	1345
2	420

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	30000
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	5
3rd row	5
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
5	20831	69.4%
4	6020	20.1%
1	1384	4.6%
3	1345	4.5%
2	420	1.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5	20831	69.4%
4	6020	20.1%
1	1384	4.6%
3	1345	4.5%
2	420	1.4%

Most occurring characters

Value	Count	Frequency (%)
5	20831	69.4%
4	6020	20.1%
1	1384	4.6%
3	1345	4.5%
2	420	1.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
5	20831	69.4%
4	6020	20.1%
1	1384	4.6%
3	1345	4.5%
2	420	1.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
5	20831	69.4%
4	6020	20.1%
1	1384	4.6%
3	1345	4.5%
2	420	1.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
5	20831	69.4%
4	6020	20.1%
1	1384	4.6%
3	1345	4.5%
2	420	1.4%

reviews_text
Text

Distinct	27282
Distinct (%)	90.9%
Missing	0
Missing (%)	0.0%
Memory size	6.9 MiB

Length

Max length	5865
Median length	1257
Mean length	183.05697
Min length	2

Characters and Unicode

Total characters	5491709
Distinct characters	94
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	24711 ?
Unique (%)	82.4%

Sample

1st row	i love this album. it's very good. more to the hip hop side than her current pop sound.. SO HYPE! i listen to this everyday at the gym! i give it 5star rating all the way. her metaphors are just crazy.
2nd row	Good flavor. This review was collected as part of a promotion.
3rd row	Good flavor.
4th row	I read through the reviews on here before looking in to buying one of the couples lubricants, and was ultimately disappointed that it didn't even live up to the reviews I had read. For starters, neither my boyfriend nor I could notice any sort of enhanced or 'captivating' sensation. What we did notice, however, was the messy consistency that was reminiscent of a more liquid-y vaseline. It was difficult to clean up, and was not a pleasant, especially since it lacked the 'captivating' sensation we had both been expecting. I'm disappointed that I paid as much as I did for a lube that I won't use again, when I could just use their normal personal lubricant for 1) less money and 2) less mess.
5th row	My husband bought this gel for us. The gel caused irritation and it felt like it was burning my skin. I wouldn't recommend this gel.

Value	Count	Frequency (%)
the	42938	4.2%
i	37866	3.7%
and	32804	3.2%
a	29963	2.9%
this	25934	2.5%
it	23211	2.3%
to	23140	2.2%
of	21078	2.0%
my	17191	1.7%
was	15854	1.5%
Other values (21942)	761595	73.8%

Most occurring characters

Value	Count	Frequency (%)
	1001591	18.2%
e	507270	9.2%
t	372623	6.8%
o	352362	6.4%
a	328509	6.0%
i	290020	5.3%
s	284155	5.2%
n	250464	4.6%
r	240567	4.4%
h	200231	3.6%
Other values (84)	1663917	30.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5491709	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	1001591	18.2%
e	507270	9.2%
t	372623	6.8%
o	352362	6.4%
a	328509	6.0%
i	290020	5.3%
s	284155	5.2%
n	250464	4.6%
r	240567	4.4%
h	200231	3.6%
Other values (84)	1663917	30.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5491709	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	1001591	18.2%
e	507270	9.2%
t	372623	6.8%
o	352362	6.4%
a	328509	6.0%
i	290020	5.3%
s	284155	5.2%
n	250464	4.6%
r	240567	4.4%
h	200231	3.6%
Other values (84)	1663917	30.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5491709	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	1001591	18.2%
e	507270	9.2%
t	372623	6.8%
o	352362	6.4%
a	328509	6.0%
i	290020	5.3%
s	284155	5.2%
n	250464	4.6%
r	240567	4.4%
h	200231	3.6%
Other values (84)	1663917	30.3%

reviews_title
Text

Distinct	18535
Distinct (%)	62.2%
Missing	190
Missing (%)	0.6%
Memory size	2.1 MiB

Length

Max length	180
Median length	104
Mean length	18.096444
Min length	1

Characters and Unicode

Total characters	539455
Distinct characters	90
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16145 ?
Unique (%)	54.2%

Sample

1st row	Just Awesome
2nd row	Good
3rd row	Good
4th row	Disappointed
5th row	Irritation

Value	Count	Frequency (%)
great	6103	6.4%
movie	3168	3.3%
product	3147	3.3%
love	2926	3.1%
the	2712	2.8%
good	2201	2.3%
this	1756	1.8%
wipes	1709	1.8%
for	1688	1.8%
clorox	1631	1.7%
Other values (5733)	68509	71.7%

Most occurring characters

Value	Count	Frequency (%)
	65745	12.2%
e	54783	10.2%
o	39514	7.3%
t	33636	6.2%
r	28581	5.3%
i	28533	5.3%
a	27903	5.2%
s	24564	4.6%
n	20992	3.9%
l	19697	3.7%
Other values (80)	195507	36.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	539455	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	65745	12.2%
e	54783	10.2%
o	39514	7.3%
t	33636	6.2%
r	28581	5.3%
i	28533	5.3%
a	27903	5.2%
s	24564	4.6%
n	20992	3.9%
l	19697	3.7%
Other values (80)	195507	36.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	539455	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	65745	12.2%
e	54783	10.2%
o	39514	7.3%
t	33636	6.2%
r	28581	5.3%
i	28533	5.3%
a	27903	5.2%
s	24564	4.6%
n	20992	3.9%
l	19697	3.7%
Other values (80)	195507	36.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	539455	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	65745	12.2%
e	54783	10.2%
o	39514	7.3%
t	33636	6.2%
r	28581	5.3%
i	28533	5.3%
a	27903	5.2%
s	24564	4.6%
n	20992	3.9%
l	19697	3.7%
Other values (80)	195507	36.2%

reviews_userCity
Text

MISSING

Distinct	977
Distinct (%)	50.6%
Missing	28071
Missing (%)	93.6%
Memory size	1001.0 KiB

Length

Max length	40
Median length	22
Mean length	8.6360809
Min length	2

Characters and Unicode

Total characters	16659
Distinct characters	55
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	705 ?
Unique (%)	36.5%

Sample

1st row	Los Angeles
2nd row	Rohnert Park
3rd row	Brooklyn
4th row	Brooklyn
5th row	Houston

Value	Count	Frequency (%)
new	51	2.1%
san	47	2.0%
city	40	1.7%
chicago	34	1.4%
houston	32	1.3%
york	31	1.3%
los	26	1.1%
angeles	26	1.1%
atlanta	23	1.0%
boston	22	0.9%
Other values (1000)	2062	86.1%

Most occurring characters

Value	Count	Frequency (%)
a	1544	9.3%
e	1402	8.4%
o	1337	8.0%
n	1300	7.8%
i	1126	6.8%
l	1099	6.6%
r	937	5.6%
t	894	5.4%
s	789	4.7%
	465	2.8%
Other values (45)	5766	34.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	16659	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1544	9.3%
e	1402	8.4%
o	1337	8.0%
n	1300	7.8%
i	1126	6.8%
l	1099	6.6%
r	937	5.6%
t	894	5.4%
s	789	4.7%
	465	2.8%
Other values (45)	5766	34.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	16659	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1544	9.3%
e	1402	8.4%
o	1337	8.0%
n	1300	7.8%
i	1126	6.8%
l	1099	6.6%
r	937	5.6%
t	894	5.4%
s	789	4.7%
	465	2.8%
Other values (45)	5766	34.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	16659	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1544	9.3%
e	1402	8.4%
o	1337	8.0%
n	1300	7.8%
i	1126	6.8%
l	1099	6.6%
r	937	5.6%
t	894	5.4%
s	789	4.7%
	465	2.8%
Other values (45)	5766	34.6%

reviews_userProvince
Categorical

HIGH CORRELATION MISSING

Distinct	42
Distinct (%)	24.7%
Missing	29830
Missing (%)	99.4%
Memory size	1.8 MiB

CA	19
TX	16
FL	15
OH	15
NJ	10
Other values (37)	95

Length

Max length	10
Median length	2
Mean length	2.0941176
Min length	2

Characters and Unicode

Total characters	356
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	8.2%

Sample

1st row	MI
2nd row	TX
3rd row	TX
4th row	ME
5th row	OH

Common Values

Value	Count	Frequency (%)
CA	19	0.1%
TX	16	0.1%
FL	15	0.1%
OH	15	0.1%
NJ	10	< 0.1%
MI	8	< 0.1%
IN	5	< 0.1%
NY	5	< 0.1%
AZ	5	< 0.1%
WA	4	< 0.1%
Other values (32)	68	0.2%
(Missing)	29830	99.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	19	11.2%
tx	16	9.4%
fl	15	8.8%
oh	15	8.8%
nj	10	5.9%
mi	8	4.7%
in	5	2.9%
ny	5	2.9%
az	5	2.9%
tn	4	2.4%
Other values (32)	68	40.0%

Most occurring characters

Value	Count	Frequency (%)
A	49	13.8%
N	33	9.3%
C	28	7.9%
L	25	7.0%
O	24	6.7%
I	24	6.7%
T	23	6.5%
M	20	5.6%
H	18	5.1%
X	16	4.5%
Other values (26)	96	27.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	356	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	49	13.8%
N	33	9.3%
C	28	7.9%
L	25	7.0%
O	24	6.7%
I	24	6.7%
T	23	6.5%
M	20	5.6%
H	18	5.1%
X	16	4.5%
Other values (26)	96	27.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	356	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	49	13.8%
N	33	9.3%
C	28	7.9%
L	25	7.0%
O	24	6.7%
I	24	6.7%
T	23	6.5%
M	20	5.6%
H	18	5.1%
X	16	4.5%
Other values (26)	96	27.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	356	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	49	13.8%
N	33	9.3%
C	28	7.9%
L	25	7.0%
O	24	6.7%
I	24	6.7%
T	23	6.5%
M	20	5.6%
H	18	5.1%
X	16	4.5%
Other values (26)	96	27.0%

reviews_username
Text

Distinct	24914
Distinct (%)	83.2%
Missing	63
Missing (%)	0.2%
Memory size	1.9 MiB

Length

Max length	59
Median length	34
Mean length	8.0268898
Min length	1

Characters and Unicode

Total characters	240301
Distinct characters	49
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	21304 ?
Unique (%)	71.2%

Sample

1st row	joshua
2nd row	dorothy w
3rd row	dorothy w
4th row	rebecca
5th row	walker557

Value	Count	Frequency (%)
the	62	0.2%
customer	56	0.2%
mike	43	0.1%
byamazon	43	0.1%
chris	33	0.1%
m	26	0.1%
b	23	0.1%
lisa	20	0.1%
d	20	0.1%
a	20	0.1%
Other values (25015)	30803	98.9%

Most occurring characters

Value	Count	Frequency (%)
a	21155	8.8%
e	21024	8.7%
i	13809	5.7%
r	13783	5.7%
n	13493	5.6%
o	12621	5.3%
s	12192	5.1%
l	11852	4.9%
m	10973	4.6%
t	9900	4.1%
Other values (39)	99499	41.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	240301	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	21155	8.8%
e	21024	8.7%
i	13809	5.7%
r	13783	5.7%
n	13493	5.6%
o	12621	5.3%
s	12192	5.1%
l	11852	4.9%
m	10973	4.6%
t	9900	4.1%
Other values (39)	99499	41.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	240301	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	21155	8.8%
e	21024	8.7%
i	13809	5.7%
r	13783	5.7%
n	13493	5.6%
o	12621	5.3%
s	12192	5.1%
l	11852	4.9%
m	10973	4.6%
t	9900	4.1%
Other values (39)	99499	41.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	240301	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	21155	8.8%
e	21024	8.7%
i	13809	5.7%
r	13783	5.7%
n	13493	5.6%
o	12621	5.3%
s	12192	5.1%
l	11852	4.9%
m	10973	4.6%
t	9900	4.1%
Other values (39)	99499	41.4%

user_sentiment
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	1.9 MiB

Positive	26632
Negative	3367

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	239992
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Positive
2nd row	Positive
3rd row	Positive
4th row	Negative
5th row	Negative

Common Values

Value	Count	Frequency (%)
Positive	26632	88.8%
Negative	3367	11.2%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
positive	26632	88.8%
negative	3367	11.2%

Most occurring characters

Value	Count	Frequency (%)
i	56631	23.6%
e	33366	13.9%
t	29999	12.5%
v	29999	12.5%
P	26632	11.1%
o	26632	11.1%
s	26632	11.1%
N	3367	1.4%
g	3367	1.4%
a	3367	1.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	239992	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	56631	23.6%
e	33366	13.9%
t	29999	12.5%
v	29999	12.5%
P	26632	11.1%
o	26632	11.1%
s	26632	11.1%
N	3367	1.4%
g	3367	1.4%
a	3367	1.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	239992	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	56631	23.6%
e	33366	13.9%
t	29999	12.5%
v	29999	12.5%
P	26632	11.1%
o	26632	11.1%
s	26632	11.1%
N	3367	1.4%
g	3367	1.4%
a	3367	1.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	239992	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	56631	23.6%
e	33366	13.9%
t	29999	12.5%
v	29999	12.5%
P	26632	11.1%
o	26632	11.1%
s	26632	11.1%
N	3367	1.4%
g	3367	1.4%
a	3367	1.4%

Auto

Heatmap
Table

	reviews_didPurchase	reviews_doRecommend	reviews_rating	reviews_userProvince	user_sentiment
reviews_didPurchase	1.000	0.000	0.054	0.000	0.043
reviews_doRecommend	0.000	1.000	0.834	0.806	0.199
reviews_rating	0.054	0.834	1.000	0.123	0.244
reviews_userProvince	0.000	0.806	0.123	1.000	0.000
user_sentiment	0.043	0.199	0.244	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	brand	categories	manufacturer	name	reviews_date	reviews_didPurchase	reviews_doRecommend	reviews_rating	reviews_text	reviews_title	reviews_userCity	reviews_userProvince	reviews_username	user_sentiment
0	AV13O1A8GV-KLJ3akUyj	Universal Music	Movies, Music & Books,Music,R&b,Movies & TV,Movie Bundles & Collections,CDs & Vinyl,Rap & Hip-Hop,Bass,Music on CD or Vinyl,Rap,Hip-Hop,Mainstream Rap,Pop Rap	Universal Music Group / Cash Money	Pink Friday: Roman Reloaded Re-Up (w/dvd)	2012-11-30T06:21:45.000Z	NaN	NaN	5	i love this album. it's very good. more to the hip hop side than her current pop sound.. SO HYPE! i listen to this everyday at the gym! i give it 5star rating all the way. her metaphors are just crazy.	Just Awesome	Los Angeles	NaN	joshua	Positive
1	AV14LG0R-jtxr-f38QfS	Lundberg	Food,Packaged Foods,Snacks,Crackers,Snacks, Cookies & Chips,Rice Cakes,Cakes	Lundberg	Lundberg Organic Cinnamon Toast Rice Cakes	2017-07-09T00:00:00.000Z	True	NaN	5	Good flavor. This review was collected as part of a promotion.	Good	NaN	NaN	dorothy w	Positive
2	AV14LG0R-jtxr-f38QfS	Lundberg	Food,Packaged Foods,Snacks,Crackers,Snacks, Cookies & Chips,Rice Cakes,Cakes	Lundberg	Lundberg Organic Cinnamon Toast Rice Cakes	2017-07-09T00:00:00.000Z	True	NaN	5	Good flavor.	Good	NaN	NaN	dorothy w	Positive
3	AV16khLE-jtxr-f38VFn	K-Y	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants	K-Y	K-Y Love Sensuality Pleasure Gel	2016-01-06T00:00:00.000Z	False	False	1	I read through the reviews on here before looking in to buying one of the couples lubricants, and was ultimately disappointed that it didn't even live up to the reviews I had read. For starters, neither my boyfriend nor I could notice any sort of enhanced or 'captivating' sensation. What we did notice, however, was the messy consistency that was reminiscent of a more liquid-y vaseline. It was difficult to clean up, and was not a pleasant, especially since it lacked the 'captivating' sensation we had both been expecting. I'm disappointed that I paid as much as I did for a lube that I won't use again, when I could just use their normal personal lubricant for 1) less money and 2) less mess.	Disappointed	NaN	NaN	rebecca	Negative
4	AV16khLE-jtxr-f38VFn	K-Y	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants	K-Y	K-Y Love Sensuality Pleasure Gel	2016-12-21T00:00:00.000Z	False	False	1	My husband bought this gel for us. The gel caused irritation and it felt like it was burning my skin. I wouldn't recommend this gel.	Irritation	NaN	NaN	walker557	Negative
5	AV16khLE-jtxr-f38VFn	K-Y	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants	K-Y	K-Y Love Sensuality Pleasure Gel	2016-04-20T00:00:00.000Z	False	False	1	My boyfriend and I bought this to spice things up in the bedroom and we were both highly disappointed in this product. We bought this one because we absolutely love the ky yours and mine and we thought this would have a similar affect but it did absolutely nothing. Do not buy.	Not worth it	NaN	NaN	samantha	Negative
6	AV16khLE-jtxr-f38VFn	K-Y	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants	K-Y	K-Y Love Sensuality Pleasure Gel	2016-02-08T00:00:00.000Z	False	False	1	Bought this earlier today and was excited to check it out. Based on the product description I was expecting something but it was just like the regular KY. We are fans of the his and hers so we just expected more and were left a little disappointed.	Disappointing	NaN	NaN	raeanne	Negative
7	AV16khLE-jtxr-f38VFn	K-Y	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants	K-Y	K-Y Love Sensuality Pleasure Gel	2016-02-21T00:00:00.000Z	False	False	1	I bought this product for my husband and I to try and we were not impressed at all. There was no tingling or warming. It left us both very sticky. I have used KY products in the past (loved KY his and hers) but this one was disappointing.	Not happy at all	NaN	NaN	kimmie	Negative
8	AV16khLE-jtxr-f38VFn	K-Y	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants	K-Y	K-Y Love Sensuality Pleasure Gel	2016-03-28T00:00:00.000Z	False	False	1	My husband and I bought this for some extra fun. We werevboth extremely disappointed. Especially for the price! Do not waste your money on this product. We felt nothing but a sticky mess from it.	Very disappointing	NaN	NaN	cassie	Negative
9	AV16khLE-jtxr-f38VFn	K-Y	Personal Care,Medicine Cabinet,Lubricant/Spermicide,Health,Sexual Wellness,Lubricants	K-Y	K-Y Love Sensuality Pleasure Gel	2016-03-21T00:00:00.000Z	False	False	1	Got as a surprise for my husband there is nothing special about it just a lube save the money and get plain KY if you just need a lube wish I could return it for a refund	Don't buy	NaN	NaN	moore222	Positive

	id	brand	categories	manufacturer	name	reviews_date	reviews_didPurchase	reviews_doRecommend	reviews_rating	reviews_text	reviews_title	reviews_userCity	reviews_userProvince	reviews_username	user_sentiment
29990	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2016-12-26T00:00:00.000Z	False	True	5	This whole set of these (mask, shampoo and conditioner) works lovely. My roots get oily quickly and with this, they didn't! The smells of the mask and shampoo are alright, but I think the conditioner smells AMAZING. Recommend for anyone with the same oily root/dry ends problem. I had received these products free/complimentary for testing purposes. All opinions are my own. This review was collected as part of a promotion.	Smells Amazing!	NaN	NaN	emily646	Positive
29991	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-07T00:00:00.000Z	False	True	5	Took the 48 hour hair challenge using the shampoo, conditioner and clay mask. this was the 1st time I've heard of using clay. It worked good. My hair was clean. It smells good. It lasted 48 hours without getting oily. Received these products free for testing purposes but all opinions are my own. This review was collected as part of a promotion.	Great clay products!	NaN	NaN	meganjoywolfe	Positive
29992	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2016-12-16T00:00:00.000Z	False	True	5	I absolutely love the smell of this product! I have fine hair that is oily at the roots but the ends are dry. This left my hair feeling soft, the ends are not dry, and I didn't have to wash my hair last night (which I have to usually wash my hair every night). I couldn't be happier with this product and will most definitely be purchasing it again. I received these products free/complimentary for testing purposes, but all opinions are your own. This review was collected as part of a promotion.	Smells Amazing	NaN	NaN	kjb2205	Positive
29993	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-23T00:00:00.000Z	False	True	5	I seriously was so surprised after my shower how soft and healthy my shaft and ends felt and looked! not to mention super soft!! i received this product free for my review. This review was collected as part of a promotion.	Ends feel so soft!	NaN	NaN	maryyyyyalice	Positive
29994	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-14T00:00:00.000Z	False	True	5	I got to try this conditioner for free and boy am I glad I did! It's amazing. It leaves your hair so soft and manageable and smells even more amazing! I would recommend anyone who wants great feeling hair that's not oily or dry to give this a try, you won't be disappointed. This review was collected as part of a promotion.	By far, my new favorite conditioner	NaN	NaN	smartthunny	Positive
29995	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-23T00:00:00.000Z	False	True	5	I got this conditioner with Influenster to try it and im loving it so far, i have oily hair so i use it only in the ends of my hair and feels amazing, so soft and no mess!! This review was collected as part of a promotion.	Softness!!	NaN	NaN	laurasnchz	Positive
29996	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-27T00:00:00.000Z	False	True	5	I love it , I received this for review purposes from influenster and it leaves my hair feeling fresh and smelling great	I love it	NaN	NaN	scarlepadilla	Positive
29997	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-21T00:00:00.000Z	False	True	5	First of all I love the smell of this product. After you wash your hair it is so smooth and easy to brush! I did receive this product from influenster for testing purposes but all opinions ARE my own! This review was collected as part of a promotion.	Hair is so smooth after use	NaN	NaN	liviasuexo	Positive
29998	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-11T00:00:00.000Z	False	True	5	I received this through Influenster and will never go back to anything else! I normally don't use conditioner because my hair is so oily and fine. This does not make my hair feel heavy, and it doesn't get oily during the day! It really is fantastic and plan on buying it in the future! This review was collected as part of a promotion.	Perfect for my oily hair!	NaN	NaN	ktreed95	Positive
29999	AVpfW8y_LJeJML437ySW	L'oreal Paris	Beauty,Hair Care,Shampoo & Conditioner,Holiday Shop,Christmas,Featured Brands,Health & Beauty,L'oreal,Personal Care,Hair Treatments,Conditioner	L'oreal Paris	L'or233al Paris Elvive Extraordinary Clay Rebalancing Conditioner - 12.6 Fl Oz	2017-01-19T00:00:00.000Z	False	True	5	I received this product complimentary from influenster and it has really saved my hair. This product really gives the extra boost of health and strength to bring hair back to life. It hasn't helped my hair in so many ways. This review was collected as part of a promotion.	Conditioned into healthy	NaN	NaN	kcoopxoxo	Positive

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts